select a.dftpic as dftpic1, b.Latitude as b_Latitude, b.Longitude as b_Longitude,* from [houses] a, [base_property] b, [base_cityDistrict] c where audit=1 and a.pid = b.pid and b.did = c.id and a.del=0 and a.locker=0 and b.del=0 and b.locker=0 and a.isShowEn=0 and (a.houseprice >= 10000 and a.houseprice <= 20000) and a.houseType = 1 and (b.cnpropertyname like '%Old house in Yanqing Road%' or b.enpropertyname like '%Old house in Yanqing Road%') order by updateTime Desc, a.dftpic desc
The reality is more beautiful than you see in the picture. Super nice one bedroom house with huge outside space now is available on Yanqing Rd in FFC. This r...
located in a beautiful historically alley, This incredible home is close to all sorts of great fabulous shopping, restaurants, city plazas and several subway s...